Tabela LPerfContrServStatus

Definicja tabeli LPerfContrServStatus

Name

LPerfContrServStatus

Code

LPerfContrServStatus

Comment

 


Lista kolumn tabeli LPerfContrServStatus

Name

Code

LPerfContrServStatusID

LPerfContrServStatusID

PerfContrServStatusID

PerfContrServStatusID

ContractServicePerfID

ContractServicePerfID

PersonID

PersonID

NfzMessageID

NfzMessageID

StartDT

StartDT

Reason

Reason

Comments

Comments

Active

Active

AccountDataID

AccountDataID

NotForNFZReason

NotForNFZReason

GrouperVersion

GrouperVersion


Kolumna LPerfContrServStatusID tabeli LPerfContrServStatus

Definicja kolumny LPerfContrServStatusID tabeli LPerfContrServStatus

Name

LPerfContrServStatusID

Code

LPerfContrServStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfContrServStatusID tabeli LPerfContrServStatus

Definicja kolumny PerfContrServStatusID tabeli LPerfContrServStatus

Name

PerfContrServStatusID

Code

PerfContrServStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServicePerfID tabeli LPerfContrServStatus

Definicja kolumny ContractServicePerfID tabeli LPerfContrServStatus

Name

ContractServicePerfID

Code

ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli LPerfContrServStatus

Definicja kolumny PersonID tabeli LPerfContrServStatus

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NfzMessageID tabeli LPerfContrServStatus

Definicja kolumny NfzMessageID tabeli LPerfContrServStatus

Name

NfzMessageID

Code

NfzMessageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LPerfContrServStatus

Definicja kolumny StartDT tabeli LPerfContrServStatus

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna Reason tabeli LPerfContrServStatus

Definicja kolumny Reason tabeli LPerfContrServStatus

Name

Reason

Code

Reason

Data Type

VARCHAR2(268)

Mandatory

No

Comment

 


Kolumna Comments tabeli LPerfContrServStatus

Definicja kolumny Comments tabeli LPerfContrServStatus

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz


Kolumna Active tabeli LPerfContrServStatus

Definicja kolumny Active tabeli LPerfContrServStatus

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna AccountDataID tabeli LPerfContrServStatus

Definicja kolumny AccountDataID tabeli LPerfContrServStatus

Name

AccountDataID

Code

AccountDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID pozycji rozliczeniowej ze STER


Kolumna NotForNFZReason tabeli LPerfContrServStatus

Definicja kolumny NotForNFZReason tabeli LPerfContrServStatus

Name

NotForNFZReason

Code

NotForNFZReason

Data Type

VARCHAR2(1024)

Mandatory

No

Comment

Przyczyna statusu "nie do rozliczenia" swiadczenia


Kolumna GrouperVersion tabeli LPerfContrServStatus

Definicja kolumny GrouperVersion tabeli LPerfContrServStatus

Name

GrouperVersion

Code

GrouperVersion

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Lista kluczy tabeli LPerfContrServStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPerfContrServStatus

Definicja klucza Identifier_1 tabeli LPerfContrServStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment